package com.skq.mapper;

import com.skq.pojo.Category;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @author skq
 * @data 2024/6/7
 */
public interface CategoryMapper {
    //添加分类
    @Insert("insert into category(category_name, category_alias, create_user, create_time, update_time) " +
            "values (#{categoryName}, #{categoryAlias}, #{createUser}, #{createTime}, #{updateTime})")
    void add(Category category);

    //查询分类列表
    @Select("select * from category where create_user=#{id}")
    List<Category> list(Integer id);

    //根据id查询分类详情
    @Select("select * from category where id=#{id};")
    Category findById(Integer id);

    //更新分类
    @Update("update category set category_name=#{categoryName}, category_alias=#{categoryAlias}, update_time=#{updateTime} " +
            "where id=#{id} and create_user=#{createUser}")
    void update(Category category);

    //删除分类
    @Delete("delete from category where id=#{id} and create_user=#{createUser};")
    void delete(Integer id, Integer createUser);
}
